SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108006 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108006 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846813,493542,542676,764791,602171,945752,376013,637530,12875,772233,184027,833077,731797,591229,546341,618472,460880,111343,355938,155711,562574,140234,636718,690506,227150,191262,779865,84043,353770,180901,474122,544642,1040204,17080,216094,175229,842604,384230,878873,768112,320492,990301,913542,574802,978046,532564,26538,538460,970901,267312,984390,28816,654559,893238,169075,69557,294946,935214,691474,177570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108006 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108006 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]