SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001991s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 951035 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 951035 [ RunTime:0.002980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239268,1023099,265117,863125,150366,310946,151848,487145,410289,884714,680476,154572,1039351,383090,819467,713042,699521,55029,573098,1026634,140330,163928,112876,959289,495178,514690,621229,765096,582412,841777,992621,826015,733180,151466,456687,451930,515069,759087,366324,266380,329799,23891,381847,643756,328723,347262,889183,997444,961706,889776,727992,223851,429912,880922,950275,795924,940770,113700,473185,778477) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001862s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 951035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 951035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000592s ]