SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001840s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43343 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43343 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187865,476085,14512,96237,778286,961261,336833,319353,1008447,824448,1010819,33070,163058,564390,790047,128547,527025,848667,531717,208417,436451,287009,1014649,794677,346089,1024047,695811,759829,667743,191665,189620,305040,101378,218202,71527,857647,401361,332648,167639,120306,445361,974089,337897,949830,398095,860253,987205,242710,1003470,182240,216165,913760,228042,241195,151201,608069,473295,417742,781923,760124) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000520s ]