SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576226 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576226 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196980,634718,1010628,168400,713367,472532,813961,194929,574281,373915,525266,46910,663181,903401,106621,703072,484345,281675,310340,368033,318664,49182,44947,973179,506012,980974,1031097,1024658,923414,1015059,325034,400774,970789,745157,377332,433873,48431,456440,748216,590275,652744,636685,275353,551269,627051,783635,904521,100157,1041197,181827,993014,537757,93886,15354,426229,485599,422281,123686,351124,508591) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576226 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000618s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576226 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]