SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027884 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027884 [ RunTime:0.001877s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (340811,664357,1017273,648273,494026,165839,302817,256675,916583,668752,412449,185138,598934,755863,239022,408303,41358,418962,108987,623017,1011259,56920,325236,495259,297762,487230,400501,557541,167653,595321,341085,509849,980956,393146,418128,737527,150834,715442,300306,156566,311659,810846,337600,418217,226901,149751,626131,55194,261833,743400,319922,708290,1346,78948,209303,828992,855251,12615,784967,359223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027884 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027884 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]