SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50592 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50592 [ RunTime:0.002705s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (56654,959153,144430,712308,311059,821699,29493,156884,215448,882939,922241,579799,391228,680226,25191,506156,297314,385028,191880,853972,922081,107095,353130,356827,991826,218895,271134,376735,562038,551769,401189,587579,163710,1017885,729020,4105,429520,75428,843137,568714,1024744,352595,934238,176092,75758,870418,560026,489716,152417,719681,737278,622172,609016,483636,196112,482072,117907,546556,889623,351249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50592 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50592 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]