SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004467s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405266 LIMIT 1 [ RunTime:0.002918s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405266 [ RunTime:0.006714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509641,743278,196530,875193,694283,488584,222310,215449,371985,60554,309271,797282,1045609,985988,165383,248813,290841,901611,353973,79754,581198,944595,1024504,661624,52056,301482,543308,954386,893499,1041586,237456,840495,1030255,738549,130260,248196,79276,788439,727475,879993,798721,454428,713805,930960,718964,748502,720302,51550,628134,219285,578689,165638,888692,43883,495397,992898,780591,879431,808880,697671) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405266 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405266 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003222s ]