SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001971s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017422 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017422 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (194293,421907,179794,335974,785889,885874,225225,783921,889683,569995,478582,384192,259585,921721,749929,308384,882320,392369,152437,789261,123637,441554,446193,712721,298284,272361,1047709,415979,584461,692018,131348,636044,517883,982366,1021598,453742,278171,162810,649334,532414,577861,862658,63726,229365,835142,956484,386131,703126,685485,745312,107209,846277,499187,233706,549863,805138,61206,789530,1040592,275565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000757s ]