SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 242088 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 242088 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546211,199795,16590,300629,126401,260254,187608,132604,425130,322594,414765,988792,761723,79979,874346,140507,294696,535884,559368,288671,404347,772128,619076,251875,741967,652899,226101,42804,898774,180145,530247,761569,924604,1045426,467972,494320,649290,876248,151631,49510,194194,914517,484547,44100,932937,1039435,727410,809204,855694,489459,435355,371455,848040,450917,326449,138134,1019114,731678,692284,265815) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 242088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 242088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]