SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 495300 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 495300 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (518720,559766,125196,212313,16447,296163,851293,397961,299015,259029,910299,899609,720611,722124,25674,20818,418049,283447,750911,176115,351463,1010645,160257,592659,1016267,233996,279203,689014,296253,344288,72665,39693,977427,195508,319647,418104,179323,49394,543126,809855,103884,761350,761208,919224,443166,702047,578227,695819,656585,361525,270029,947305,509153,531349,338589,113582,837754,336478,674867,971854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 495300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 495300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]