SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002570s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531112 LIMIT 1 [ RunTime:0.000757s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531112 [ RunTime:0.003613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (625612,497799,92657,83436,640109,95793,196380,120219,946092,312532,945141,759053,331113,639909,656335,365398,956362,37944,844638,747678,327538,610999,275000,323659,904262,835888,609370,980137,959149,181897,111341,436174,171854,11510,520622,870939,694801,982685,61901,105158,499528,617266,633977,462526,848635,964038,356871,130318,499187,1004083,612241,901661,718077,916912,1045095,141887,771351,299328,137728,798759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]