SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200017 LIMIT 1 [ RunTime:0.001177s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200017 [ RunTime:0.001665s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149618,245343,928100,869721,187540,722804,801573,566730,257746,353970,140756,3325,367174,908165,354977,937170,68318,837016,395376,503827,712186,440749,273098,70923,701467,564831,665448,778480,72371,191359,847514,94056,985030,868454,983065,665798,412327,588140,194924,925892,903521,3824,922220,397344,414289,1029522,612132,1028989,177741,959192,523396,471401,506245,769348,287708,80980,839741,731284,633289,481966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001587s ]