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` = 341997 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341997 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249004,536113,219716,862581,925975,910607,32279,334712,408119,829908,782130,263257,915911,563937,838267,995553,29274,353055,388817,1013048,674545,455839,95989,14468,76930,1021995,565330,56434,394820,466336,840781,440207,353268,536516,29073,996331,59177,935753,646422,992312,758404,568673,345365,411602,215641,25365,1022729,782189,128185,127909,134298,838012,511719,540914,766698,237674,362348,433637,934042,280978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341997 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341997 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]