SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002091 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002091 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (27798,179824,132128,1023407,451534,803613,696644,87389,960190,110339,367806,952487,188440,212867,153116,132535,633536,614498,590359,301436,921071,999588,956228,1044864,94517,54024,473728,981606,954104,975385,957339,1019457,732679,398084,751484,782340,782615,557188,278185,429381,534948,883951,378896,319244,155638,39796,243037,509243,298709,465833,113026,40189,716936,1047290,203339,831042,130662,385415,922139,67396) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]