SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 403430 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 403430 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (116998,610325,754959,484765,215472,16388,847409,244694,392281,947809,478562,557054,208117,763235,90047,543902,853473,418186,515551,378367,250743,187287,253397,128153,511254,256134,850921,350921,452513,41842,338473,600599,784367,927588,378657,349791,11576,224997,5720,878151,910547,811318,1038415,312611,935761,859048,613409,360506,478924,908309,477016,603397,451322,988536,97995,121599,510828,956852,829199,802553) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000967s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 403430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 403430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]