SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002758s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501605 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501605 [ RunTime:0.002842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884269,137943,647267,827710,184245,57582,338237,91960,579810,522022,400177,737366,339455,169032,920257,1009034,960773,762953,295375,505091,120836,1033414,276304,1031334,536900,645291,275577,125069,83488,449575,384912,726426,581432,774514,113883,92687,962838,264232,706259,209899,251657,383670,541036,474194,615284,438887,960515,422996,189111,863260,298845,35898,76742,25443,298199,603712,870772,1010258,854495,186355) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001771s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501605 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501605 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]