SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462308 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462308 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709588,835426,534871,602800,907200,748525,333373,577407,105118,791590,177800,991842,225060,846280,638936,492614,185712,752073,493453,402906,326040,318812,39837,52828,212987,389612,631086,854797,454581,1002909,829842,803179,780121,1010871,664008,244666,147176,485412,23824,319283,124696,93780,113398,554790,452734,905129,650336,1025966,575803,92448,467568,953520,484604,461484,299691,343128,813553,351149,435960,1005309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001618s ]