SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 184043 LIMIT 1 [ RunTime:0.000451s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 184043 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (530332,922250,798746,455642,218997,866929,15118,487718,291891,320499,779599,260801,1012573,441161,980812,210454,165814,134979,211356,962487,747708,726547,966585,46265,987155,816246,462562,1039817,28142,695303,468713,1042196,706366,924459,555856,736210,264634,686025,412554,534756,724107,554998,83535,303414,410155,772950,896820,196357,353299,1048473,388527,538958,624702,963790,924786,153262,438638,290264,1002636,453248) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 184043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000437s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 184043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]