SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001328s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102018 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102018 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601134,416684,45618,35831,292086,579346,15254,797759,129721,263780,800055,167124,425106,709972,413895,818562,133834,905709,830776,276479,585308,695618,941489,859094,350346,474956,251945,848599,618055,691173,849459,553146,771558,414908,702642,936152,350846,837026,292181,349114,712267,600335,596806,196817,843706,124062,429835,227833,553828,824382,447985,961492,1026970,62130,230560,821005,865102,826088,783120,506871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000848s ]