SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001865s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 569053 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 569053 [ RunTime:0.004739s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172139,988487,814988,83868,694170,1019097,308161,899693,40636,1033119,933829,923169,344899,461626,548762,911939,274031,40644,51888,823065,1028335,1000535,937744,238375,929351,87732,344987,81279,963880,289539,854429,913819,439167,522373,186554,802648,140182,245677,633441,470218,460679,57654,761942,68862,390596,743471,583223,165588,681081,298172,816640,320502,323909,718314,431174,377372,322018,699236,515036,708660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 569053 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 569053 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003958s ]