SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545064 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545064 [ RunTime:0.004180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78191,875769,680664,473290,728220,1024847,862955,183457,671278,457914,31385,264944,673824,622627,853996,121411,163740,115585,459313,495083,872235,776250,371767,443435,518034,895300,170404,78713,321694,68150,105573,749746,134430,223220,801614,1018868,4494,200423,246739,86436,553978,899737,271334,255173,823340,631164,622977,229883,1007689,187481,737992,764685,82821,93289,1006891,200835,797477,312506,1043466,161000) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545064 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545064 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]