SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514952 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514952 [ RunTime:0.002332s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149346,994618,820830,787884,327403,397375,1011944,499702,999055,536398,475137,331944,430382,262935,91657,79387,120074,1037180,590624,39946,56997,1014111,965801,279887,477989,68299,257995,449345,851785,379287,237975,905528,465000,624506,1007781,364470,701168,844073,165073,723020,815014,145426,308371,563211,513130,57309,282514,13896,230992,1039646,324546,25490,761112,408280,179874,484965,437349,371546,823115,543979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]