SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411854 LIMIT 1 [ RunTime:0.000435s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411854 [ RunTime:0.002319s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257965,658419,29492,274312,918688,55257,773841,889505,50927,300445,964057,942388,148338,18597,40021,923835,748954,594688,288160,876525,708770,772847,253501,4643,22782,359088,827508,71136,909199,464299,712268,96537,742503,587329,783788,902061,872209,360859,582272,269035,842492,599739,159113,293537,221541,438683,121747,673446,9620,627652,842675,534011,15512,916912,221096,1048360,155947,665207,364832,915965) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001091s ]