SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001321s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1035378 LIMIT 1 [ RunTime:0.000939s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1035378 [ RunTime:0.006638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (685713,553417,743538,201211,263081,142675,3842,933774,933969,47910,212484,841381,62830,902546,228255,1001149,452787,741698,204501,1046821,599749,832458,457746,277260,505903,645792,912929,491176,743810,328449,756350,973568,494801,879821,41740,836336,478354,317863,166274,930131,916619,892021,446230,848412,414980,710345,845305,124797,381362,41400,85421,819180,420512,809072,579607,835674,698848,173434,152702,985560) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1035378 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1035378 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]