SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314684 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314684 [ RunTime:0.002780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816679,623478,718944,199600,799852,467772,159825,485189,580192,534493,1021033,564662,288360,683386,519184,776165,675066,202498,537263,161972,761964,256049,317209,569124,996600,776446,70347,980615,1038933,809488,397880,140362,850986,166161,538748,4457,1020092,173437,705291,179006,405776,406479,1023158,253404,193136,52909,685851,630522,446657,937460,860461,691653,27957,883110,494431,892841,933585,960493,492202,731888) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314684 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314684 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]