SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001579s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 892009 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 892009 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (465361,475040,698162,222503,571536,989977,402317,616636,620822,147698,1026321,638736,512160,928328,108430,1000302,943170,1020231,453363,358704,911674,919064,40760,10223,205190,886705,711396,328903,725313,187013,633948,437180,934838,805696,866156,930785,843923,892740,40788,330840,620006,1006835,729717,220848,23869,154945,100796,198378,724355,738794,926818,894236,683553,752484,513749,698202,60579,650670,907400,1011520) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 892009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 892009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]