SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411296 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411296 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (188277,884156,584996,884933,519163,930490,71862,684747,248772,531517,1042518,400632,362640,662130,787526,605183,152531,177932,69300,52224,534941,107321,85567,372570,212991,922767,306147,124139,754280,964858,1043115,520763,346332,532293,166436,901570,378805,402639,998613,513699,278947,59,232493,720569,4710,871586,915532,673131,281712,360148,867437,961350,161127,190179,604790,913015,56149,799567,126172,942609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411296 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000705s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411296 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000896s ]