SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 492009 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 492009 [ RunTime:0.003609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (507416,505400,543362,631871,6412,420161,330777,60417,173504,713645,621219,904817,411085,433548,567561,172188,433645,131916,399667,669709,305989,612240,339266,825116,581316,639332,300976,623022,655716,594007,225247,724253,787678,88478,244730,167571,897828,576662,668198,540742,791819,426850,470761,402589,723743,665432,143799,188735,837297,466231,844346,175289,94677,437978,166192,341736,473987,826186,343358,709224) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000971s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 492009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 492009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]