SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033571 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033571 [ RunTime:0.001988s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342657,926551,130687,506357,413316,431476,148578,927413,570360,161054,454841,499248,307152,613292,810682,364437,181788,365223,661343,344899,426699,536302,877835,255768,108430,538237,477989,541958,885998,222275,237033,854091,290561,6968,24067,464032,180455,122080,430237,490972,573225,890332,416783,839485,951806,429987,340640,792877,842931,219819,285604,369821,285596,683614,885071,584130,475144,914108,31107,664141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]