SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284010 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284010 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466002,798898,684431,424513,909681,1010733,274154,65874,898751,933902,690935,343099,645610,487634,970574,576286,849707,497943,201359,902915,625320,869857,712739,656302,410089,127756,700916,750217,777787,1046486,738885,490558,736806,435221,750721,970741,453955,783878,13397,288557,70650,785739,920280,971701,411332,281342,1031408,809959,128218,62571,234296,316082,210656,856325,931234,103515,1035140,666412,839804,500819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002467s ]