SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 197896 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 197896 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928013,675181,284480,871109,925081,714396,448195,739286,413945,798659,1046530,565971,21876,834213,526772,330486,41652,922732,741289,333666,128886,763368,683548,259390,640995,890314,955135,767718,332984,1038179,959966,390711,940108,302143,744249,525788,746981,891410,302132,303494,635133,819449,623788,871436,504808,192531,246029,658178,977150,350378,1026651,802386,595221,532738,441246,15151,97615,876053,283563,568369) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 197896 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001642s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 197896 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000594s ]