SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001110s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470411 LIMIT 1 [ RunTime:0.001008s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470411 [ RunTime:0.011333s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587237,696752,908376,66368,515903,168447,293434,343589,549016,613007,46945,715093,335686,504142,899136,35160,886896,640210,33185,147628,466692,311852,732176,1037562,205552,626712,181408,175683,432101,1048525,284484,623868,383482,810285,31602,276126,25608,335339,963383,234618,867696,898506,861460,869638,108700,512467,820904,921143,799455,801438,18204,391583,912833,311706,624506,926060,532261,697181,697071,174527) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]