SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509491 LIMIT 1 [ RunTime:0.000413s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509491 [ RunTime:0.003180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278711,981523,1019297,775918,683778,323137,608920,437817,452114,36770,629133,764153,650322,398891,456326,566307,338843,190569,538815,168421,701744,462720,543391,286962,966490,557674,775283,601671,752055,518024,96091,348404,176084,1001038,447649,547540,925066,914904,748456,33631,369722,747300,927286,194890,223419,824282,592178,533723,350832,556829,863883,845216,798476,30233,176112,996364,6544,62691,201964,443457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001822s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]