SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570539 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570539 [ RunTime:0.001591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405294,6258,967318,360052,44634,816964,519421,92156,206684,10118,677909,45241,399512,463222,768566,583352,266503,295643,529540,364886,995473,800624,26406,30941,912315,1018090,190076,459390,10084,862442,50247,358697,326010,1029559,165124,488678,501082,283286,543014,488218,789590,473349,99993,743101,949362,373608,84978,48093,332759,152375,650341,754489,714177,44475,777398,939940,493401,535360,756126,470807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]