SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 78160 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 78160 [ RunTime:0.002445s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10974,837723,960929,606962,690087,801057,915592,591358,581844,93683,525379,198489,283566,665130,165787,203336,751050,540490,980456,776867,588761,958586,139308,218280,817355,855997,32605,682795,510801,323819,916835,718865,517627,160204,920742,748167,574406,626689,510249,181874,382894,871720,343221,851667,261039,117229,381574,1047026,204714,639492,141841,974370,221738,871855,124079,506391,893193,243285,654689,141539) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 78160 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 78160 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]