SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004922s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507218 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507218 [ RunTime:0.004673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (374249,605565,289280,499673,684179,97295,526495,662058,821306,424158,852294,309856,961047,531029,756134,556520,464477,6929,19701,982899,618782,829130,6986,718242,202590,650290,922368,544658,245756,391115,307011,876189,67613,678588,562501,794482,86424,830052,1007977,561846,761713,254109,266615,72923,574942,665753,432872,517216,936378,842492,238599,931973,396553,906709,908893,33182,1027462,53100,465046,990660) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000382s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001169s ]