SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 58650 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 58650 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427485,987433,622999,141250,393587,444167,316228,687053,21686,930698,112243,409201,461113,928025,451680,533953,1001318,126979,507196,689714,626832,796962,442200,207379,1013100,215845,974349,718701,898414,303858,371087,168976,644604,895346,743393,63337,116747,666742,665807,325089,554749,755066,162921,428706,134370,656775,977374,979701,100137,934646,274239,810339,824210,620729,686116,390396,989619,34160,705338,942324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 58650 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 58650 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001411s ]