SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514313 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514313 [ RunTime:0.002523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37361,861673,646353,483960,656951,627649,591785,200123,509656,249924,981633,220369,257697,985706,199205,228893,442551,835844,954949,12318,48937,203828,270878,149808,346333,633215,3936,757070,93825,252440,173272,718526,500663,923897,980156,9705,302721,487190,338704,550624,330796,1011440,770347,101045,837616,788776,740280,890163,233509,599561,13187,1029149,408740,272153,794031,852464,1008694,86886,334950,805080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001079s ]