SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001558s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438827 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438827 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (692742,571209,957192,435770,38120,888776,394154,30374,773849,808723,1040658,380777,108036,373787,888246,190881,941346,487123,103145,971168,758596,349000,958407,804709,1029009,981098,347301,678902,549151,741108,825696,977294,298662,462883,245896,684936,805935,245233,873911,661258,1009064,76936,484359,432885,974847,987516,691893,112027,1024542,2406,944040,205803,367531,618336,174241,105825,946919,435066,893989,204047) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438827 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438827 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000448s ]