SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 440289 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 440289 [ RunTime:0.001798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (214601,126555,552009,987622,357587,451398,496561,535094,801321,638308,956908,451609,856453,287088,266480,449780,955055,844678,824188,201950,327397,343833,996380,119749,83168,779679,129210,379106,439351,270111,426692,788410,991983,368982,1037450,632466,1013917,598867,583502,759044,953304,79544,140140,1007383,741248,66634,32509,655724,479861,905450,285359,365225,851260,63690,189487,852034,555076,254484,737774,699614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000910s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 440289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 440289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]