SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445208 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445208 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299771,561466,132556,778900,196159,72561,566204,741161,984612,194691,470910,550655,864215,303392,657542,780076,632973,959758,842113,465208,665301,118491,68756,785039,586888,849787,160624,519058,293422,112669,22078,614822,90258,708626,449107,835322,858404,452018,766401,495078,872599,601762,241230,827331,970449,976216,311796,265145,123482,717824,999859,234936,402110,1045114,552252,912627,537302,331211,741471,782302) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]