SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401308 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401308 [ RunTime:0.001808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (859310,316849,689224,359928,334267,963403,742383,109714,321259,235641,74951,874404,395715,514517,307711,278577,374471,232493,903558,986335,614228,901887,98331,334271,906454,261182,376770,349260,1039029,514531,486084,1029,55856,36266,293526,572216,111468,624920,667158,678446,21831,753681,331158,647724,920064,262732,339238,416282,1012455,638630,990431,514204,776506,717498,500457,330673,1026683,295406,138576,407792) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001735s ]