SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001317s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542599 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542599 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358056,472342,842974,745359,465441,827356,255655,553467,566850,269625,388419,375740,256968,847607,784160,262246,504664,413259,349088,168205,289321,978942,70056,310929,118649,72178,440185,885420,332001,54683,484521,786334,367063,935583,111509,747506,382402,940557,507622,538218,806861,80914,657476,315241,791413,197797,937050,793058,77182,659750,680479,666558,257528,365654,652920,946539,81269,469297,196540,12559) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]