SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407770 LIMIT 1 [ RunTime:0.002146s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407770 [ RunTime:0.002150s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (255715,113155,934884,340994,479249,807843,591332,250861,659868,811409,309272,226297,285422,407642,690087,686601,112845,758203,311103,163962,39168,620985,1000491,904357,363671,364553,606788,755071,135762,122172,268451,328990,156500,711254,738975,980328,221482,40787,255918,747576,991152,602066,393918,531616,637161,265912,969485,779947,405949,891755,934580,370618,428268,444749,881193,1040172,194944,399698,972712,168517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002704s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407770 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407770 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]