SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502003 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502003 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (92670,1039612,488821,995107,868229,138910,534676,826603,697219,685838,730632,739092,290804,329648,632132,757662,279054,288197,313397,942161,396700,595721,283089,484770,801198,846114,183318,29322,477582,523648,509458,468913,48182,467952,736848,916402,873200,342324,476207,928890,228779,911759,162319,815493,855721,767420,340231,664340,706296,355842,794740,302956,760330,838842,801637,1006972,3996,1041524,381117,830962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000618s ]