SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001304s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536328 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536328 [ RunTime:0.002553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93049,131629,458861,768270,265018,381597,686739,83498,552869,121087,106172,469185,474271,488922,258418,40899,377925,700437,547745,420478,875763,444495,422486,996173,353738,568049,675159,906534,735501,172813,345155,96287,96958,214888,872121,828898,53738,18250,778217,1002255,562942,422786,802179,246068,248748,143658,972176,217124,1037973,351614,360413,195535,188785,420006,755481,313302,891133,862542,493053,789378) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]