SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299699 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299699 [ RunTime:0.001492s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (514012,723662,294085,267513,347756,707824,727560,330853,899210,235775,130910,779354,139672,384206,506574,761139,986277,257472,144535,917723,78327,444930,755217,198499,530951,903357,1040454,937370,176114,659835,39375,167178,669962,908418,115151,578290,955470,954453,718899,457254,549265,368641,1005216,833761,992384,858590,1042105,551816,283469,1045508,503857,124963,126521,137552,420213,554995,246442,133867,23937,788877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299699 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299699 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000441s ]