SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 910183 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 910183 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (471384,395217,457201,259899,1041995,696767,490240,230170,503327,140782,33926,420899,718523,465938,247389,565498,812235,1040821,524837,392277,354170,502730,562596,210271,107064,121211,1037730,27169,137516,379179,690024,824797,739811,303241,232638,356158,487640,342289,1029189,441696,750973,884434,731621,268554,617749,527952,836290,980840,443642,778664,971181,613267,703159,479337,726813,932887,865532,326182,597838,644718) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 910183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 910183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]