SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001083s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149778 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149778 [ RunTime:0.001692s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (998146,676245,509477,110541,89274,796053,755146,160850,430689,960930,749650,822315,150745,150174,37691,247055,123807,365422,480107,459178,866013,871060,332117,4166,803923,379212,344427,60124,385897,828689,807119,416200,117769,475433,205816,675321,199204,274350,652845,1024096,608327,174247,531968,28350,780779,326251,875673,637981,344120,833840,510599,456751,406445,806574,700016,177499,120740,16267,187932,416949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149778 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149778 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000414s ]