SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046318 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046318 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (568129,779576,11700,783022,334393,342176,875726,490082,928299,898148,743096,830149,1040339,474647,980772,73933,53802,928451,190900,525075,807628,239235,305270,700411,767895,565619,534266,751355,350395,922737,294227,465904,731210,726416,186890,204075,292500,598959,176991,764130,988737,510069,459400,85795,181308,367418,559746,782840,224981,861536,519436,192921,863561,855985,899905,492615,316377,394798,408906,90482) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003919s ]