SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001339s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132578 LIMIT 1 [ RunTime:0.000490s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132578 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423526,427459,92807,924602,3858,615308,195339,989943,511227,195991,383358,2439,381267,903771,631787,977044,572347,745382,546538,380675,644237,748158,753310,561621,1040651,165495,31625,374973,120542,197201,172110,712591,555189,317981,999054,974667,831758,653278,783811,919763,55658,355764,319699,314762,876139,531109,61332,391266,1001181,850141,991030,851211,490398,148261,422898,723265,778320,799540,363395,316706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002298s ]