SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201306 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201306 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (175896,534207,898230,869672,794782,671998,305565,259840,536639,662551,694808,678557,785344,887233,336607,767837,582449,454681,702731,97252,564188,63606,451341,223456,243683,135008,673315,89651,706271,943876,414387,405994,474592,299880,704924,461756,389005,161191,373386,385047,804504,1000952,383615,154418,407023,486308,659354,886386,492983,820494,978142,61909,213840,900365,504553,995257,464787,802272,269587,850932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201306 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201306 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]