SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 465329 LIMIT 1 [ RunTime:0.000467s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 465329 [ RunTime:0.001770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321201,881542,331208,124480,1027571,516645,376922,582922,172430,33910,96699,559786,27063,684194,1016761,953884,868147,751960,156464,30276,14807,44816,932574,18471,586754,87039,927327,814365,361310,1002712,573518,480724,118688,412401,910202,877354,190521,808833,925438,656475,429244,99331,807779,636900,52447,118248,445730,294032,532274,776783,539849,301083,565371,59572,221450,455178,620283,152384,858710,453476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 465329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 465329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000645s ]