SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291021 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291021 [ RunTime:0.001618s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (14789,856122,16087,698207,261147,935066,217877,362704,964733,280922,709140,509325,50201,518913,431711,1024412,609681,477698,145319,767252,889679,709112,287020,947020,56161,673641,648098,688493,69524,878567,367580,556134,642835,686048,897503,79616,759900,219141,545169,207625,173953,932728,638966,1042972,470003,822119,209085,730445,576383,819224,894398,631601,207776,926007,33649,64539,984528,706212,56096,734655) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291021 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291021 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]