SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1011512 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1011512 [ RunTime:0.003211s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507253,219788,925149,500332,668610,727942,32465,947566,1011813,1024205,611452,926508,879050,270331,432529,871068,715684,67658,274337,285972,524770,547260,658505,844270,531422,384073,727152,938220,498437,605920,93905,243855,22131,614054,592856,625334,723028,777613,274343,380068,316719,539725,685505,788689,910504,61501,1037712,1043983,116320,322587,241579,1979,310910,58496,430315,593632,107134,907694,1008589,268566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1011512 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1011512 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]