SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 602236 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 602236 [ RunTime:0.004836s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7651,110876,517122,638819,475800,504539,564264,71524,368671,940011,246840,140956,242995,106595,850989,544245,629008,801897,601828,139966,622001,656029,188008,799659,381416,444158,514815,592630,503271,111629,618632,560222,397303,986997,493754,501258,75130,39237,24369,53789,854678,616460,390885,38034,973030,754777,818889,944414,306086,96957,190486,409248,975844,409321,979327,913985,151182,671514,77344,58188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001305s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 602236 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 602236 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003612s ]