SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 11601 LIMIT 1 [ RunTime:0.000817s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 11601 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (9315,895151,504601,161481,984108,260041,446156,870954,611072,600077,956537,957961,890350,582348,710458,32532,1005885,588499,717836,111290,1004429,1044441,1040443,466867,336114,780106,483481,914267,562473,331113,537936,789547,100812,649574,76979,705294,741270,74464,341221,1312,240704,571017,274408,410181,903313,157893,446570,664953,886372,943970,536963,632234,342434,836279,258749,436784,690073,252051,743578,1024112) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 11601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 11601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000677s ]