SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489615 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489615 [ RunTime:0.002562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (932497,1039161,165757,1045213,980761,173709,522204,981493,556278,326028,9139,50209,1029229,482262,1043564,685209,685837,607398,689665,607242,737928,710554,928281,536723,244344,76915,288208,560451,629136,966882,69011,433238,741201,441688,687451,962665,45057,733508,133429,26142,794406,70136,916597,443648,494934,483959,117003,428904,287348,702428,1031928,652820,544495,499939,898616,4517,841751,389104,34761,613991) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004157s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]