SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416979 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416979 [ RunTime:0.002386s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286648,814782,682069,824598,238396,627109,706740,828507,2399,8580,1032480,18963,592416,335262,280521,373482,22850,12760,606533,1007945,682340,169735,330067,428626,247686,342547,586628,843769,641892,994898,211005,967325,105225,538513,214165,1034872,332559,979974,870850,820054,338286,950664,562866,132855,7201,329601,276167,678735,924216,362438,732522,64012,82476,142231,100783,139761,692576,957294,87229,192067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001885s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416979 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416979 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]