SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501236 LIMIT 1 [ RunTime:0.002489s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501236 [ RunTime:0.006212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10000,907524,390482,639872,708635,233197,535934,667180,109783,84048,1038254,77510,955956,479478,771308,491349,841018,434193,1040537,291276,541710,72643,729354,140905,968687,914302,775835,799242,9281,557601,59761,335952,298617,363249,455915,239632,150972,264872,795155,1020781,822838,713293,426863,728575,690859,599576,449279,152915,661163,405063,683562,196637,888471,187265,979432,801910,599271,903161,482735,210917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000541s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001438s ]