SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406537 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406537 [ RunTime:0.001535s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540644,564792,809682,1040683,1030799,740256,682624,805931,516495,422652,99414,181056,342817,875197,426155,1041435,512159,588225,140065,794641,123179,80915,2923,124316,930453,680636,423644,360019,618667,223922,980198,613473,274682,18162,985781,519024,895465,142097,300931,416763,391601,808461,954761,316554,139382,772368,135390,331093,507355,376293,404136,223643,481826,84352,166393,913121,906423,625751,248469,157593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406537 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406537 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002148s ]