SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001380s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 110108 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 110108 [ RunTime:0.002551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257736,221446,541262,475423,1028776,26217,380826,912754,256519,169680,1045341,231196,389879,371484,486918,729728,207654,667694,246501,711517,267785,218863,494537,466178,17558,413573,768357,272252,427887,154554,959590,383251,665611,921571,415967,252258,459443,611668,46146,214899,788681,143312,167889,586820,756281,511736,652349,180167,765713,140389,874974,444579,686006,524046,820347,778057,950723,524012,503774,384475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 110108 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 110108 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]