SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3800 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3800 [ RunTime:0.001581s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55961,1038921,159728,863453,286410,421500,371078,416687,62416,901040,579456,520226,569906,867824,1038015,824303,957520,199567,53757,362563,820574,957872,182151,377962,466888,720607,540533,1033776,46734,228109,662287,261987,1012971,134629,989735,528944,572328,1033924,961515,856094,56870,937976,74351,617495,317151,899815,663569,376362,570056,578410,1045710,512664,306077,798200,1048406,985618,156821,600743,145934,650398) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]