SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002500s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462011 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462011 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1046095,318903,204596,162097,508536,820667,861092,437466,262328,796905,1029305,151611,856768,530501,609331,120609,310420,945000,72782,423933,557060,595472,588351,564126,200281,968167,521516,495483,116402,402996,429291,1014937,258031,570761,999922,980578,556757,743217,139512,353002,83379,147931,293217,671166,6332,665033,1042973,342371,41523,962828,410634,1024146,933277,243144,804736,411952,787591,244482,855479,739294) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000459s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]