SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520589 LIMIT 1 [ RunTime:0.001047s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520589 [ RunTime:0.003313s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1018380,169908,61742,582133,584858,181554,497128,528116,387618,149934,972283,604231,252105,464282,575276,862978,611186,76948,808846,345596,866974,575202,241676,178036,288757,157445,302263,549957,931006,549080,855439,986001,622402,51412,611992,661649,700409,69771,330443,994342,900016,530366,145990,328471,260924,701292,955917,671832,438946,509943,763246,537233,658573,42211,11911,47800,106506,297802,806577,379765) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520589 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000686s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520589 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]