SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294607 LIMIT 1 [ RunTime:0.000432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294607 [ RunTime:0.002312s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300936,212461,642980,833673,529815,869455,517863,156871,880308,283889,207,11481,480343,854054,1042224,851802,947646,888646,200515,84296,1011330,793965,145383,791169,954423,931203,225554,750422,998076,60492,283803,291548,246763,834382,871932,717965,536161,904090,798287,892618,886748,481005,864850,737903,15636,455259,108726,372814,389557,496764,864575,858726,410343,343406,1026825,480402,425003,343720,618162,886847) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000515s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001573s ]