SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104581 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104581 [ RunTime:0.002662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958743,263905,792857,414341,222114,745448,230988,727004,598995,130846,87055,1029221,545088,374920,907998,293944,440936,592227,216210,179129,836928,649448,957979,487404,982163,93726,514227,147138,703601,83728,714095,577023,592205,906950,541643,650181,200916,179466,241120,898282,835751,501252,567513,79357,634305,744883,849343,368872,378321,787478,733016,687300,769604,413788,291290,180787,1010720,342687,769202,894970) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000587s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]