SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610396 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610396 [ RunTime:0.002190s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (451247,1015021,73909,884791,531396,935321,205296,483287,8262,198748,545622,746545,1030145,291338,283027,499078,781626,464115,106363,197,212362,426320,444561,760353,726461,282493,442688,1024649,367364,144100,128296,610246,904687,45983,324842,772509,189355,755403,680153,655696,82295,384500,103200,204164,916371,1012199,184225,752001,799657,122287,273737,916553,329958,745048,561815,486028,796191,214353,902058,355299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610396 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610396 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]