SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 394417 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 394417 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801798,813647,866037,362323,124112,419248,341673,391567,800917,579057,262620,534003,850257,59971,50293,1017610,38307,13684,325352,971892,268978,944100,41415,638089,554239,603054,455034,957308,482159,119200,229352,1023816,510500,980004,587112,823021,480009,907525,988603,543196,291459,513078,968368,923236,577674,16178,42968,67756,618838,172378,618663,579231,518354,574835,82903,1026036,721893,63840,1000420,907634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000990s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 394417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 394417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]